﻿CREATE TABLE [dbo].[VAT_INVOICE] (
    [ID]                     INT            IDENTITY (1, 1) NOT NULL,
    [NUMBER]                 NVARCHAR (50)  NOT NULL,
    [DATE]                   DATE           NULL,
    [SUM_RUB]                MONEY          NULL,
    [TYPE]                   NVARCHAR (50)  NULL,
    [IS_GUARANTY_LET]        BIT            NOT NULL,
    [GUARANTY_LET_DATE]      NVARCHAR (50)  NULL,
    [EXEC_TYPE]              NVARCHAR (50)  NULL,
    [EXEC_NUMBER]            NVARCHAR (50)  NULL,
    [LAST_UPDATE]            DATETIME2 (7)  NULL,
    [LAST_UPDATE_USER]       NVARCHAR (50)  NULL,
    [PID]                    INT            NULL,
    [NSI_ORGANIZATION_ID]    INT            NULL,
    [DESCRIPTION]            NVARCHAR (MAX) NULL,
    [INVOICE_OF_PAY_ADD_NUM] NVARCHAR (50)  NULL
);













